package org.jeecg.modules.demo.drfReviewOpinions.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.demo.drfReviewOpinions.entity.DrfReviewOpinions;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
 * @Description: 审核意见表
 * @Author: jeecg-boot
 * @Date:   2025-10-17
 * @Version: V1.0
 */
public interface DrfReviewOpinionsMapper extends BaseMapper<DrfReviewOpinions> {
    /**
     * 报存表，并返回主键
     * @param drfReviewOpinions
     */
    void saveReviewOpinion(DrfReviewOpinions drfReviewOpinions);

    /**
     * 根据论文id获取审核意见的id
     * @param id
     * @return
     */
    @Select("select id from drf_review_opinions where paper_id = #{id} AND teacher_id = #{teacherId}")
    String getOpinionsId(String id, String teacherId);
}
